<CFPARAM name="projectid" default="1">

<cfquery datasource="#application.dsn#" name="getprojects">
SELECT * FROM projects
WHERE projectid=#projectid#  
</cfquery>

<CFOUTPUT>
<TABLE border="1" cellspacing="1" cellpadding="1" width="50%">

	<TR>
		<TD>name</TD>
		<TD>#getprojects.name#</TD>
	</TR>
	<TR>
		<TD>url</TD>
		<TD>#getprojects.url#</TD>
	</TR>
	<TR>
		<TD>description</TD>
		<TD>#getprojects.description#</TD>
	</TR>
</TABLE>
</CFOUTPUT>
